package com.xdog.web3.mapper.twitter;

import com.xdog.common.mybatis.core.mapper.BaseMapperPlus;
import com.xdog.web3.domain.twitter.TwitterFollowUser;
import org.apache.ibatis.annotations.Select;
import com.baomidou.mybatisplus.annotation.InterceptorIgnore;

import java.util.List;

/**
 * Twitter关注用户Mapper接口
 */
@InterceptorIgnore(tenantLine = "true")
public interface TwitterFollowUserMapper extends BaseMapperPlus<TwitterFollowUser, TwitterFollowUser> {

    /**
     * 获取推荐的Twitter用户（忽略多租户）
     * @return Twitter用户列表
     */
    @Select("SELECT user_id, name, screen_name, profile_image_url, local_avatar_path, followers_count, following_count, tweets_count, description, verified, profile_url, create_time, update_time FROM web3_twitter_follow_user WHERE `show` = 1 ORDER BY followers_count DESC LIMIT 12")
    List<TwitterFollowUser> selectRecommendedUsers();
}
